Subscription_prediction_Profiling Report

Dataset statistics

Number of variables	16
Number of observations	1266784
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	154.6 MiB
Average record size in memory	128.0 B

Variable types

DateTime	1
Text	3
Categorical	4
Numeric	8

Alerts

`DAY_CLS` has constant value ""	Constant
`ETL_TYPE` has constant value ""	Constant
`AVG_CAR_LEN` is highly overall correlated with `OCCUPY_RATE` and 3 other fields	High correlation
`MD_TR_VOL` is highly overall correlated with `OCCUPY_RATE` and 1 other fields	High correlation
`OCCUPY_RATE` is highly overall correlated with `AVG_CAR_LEN` and 4 other fields	High correlation
`SM_TR_VOL` is highly overall correlated with `AVG_CAR_LEN` and 3 other fields	High correlation
`TRVL_SPD` is highly overall correlated with `AVG_CAR_LEN` and 3 other fields	High correlation
`TR_VOL` is highly overall correlated with `AVG_CAR_LEN` and 4 other fields	High correlation
`DETR_FAIL_YN` is highly imbalanced (> 99.9%)	Imbalance
`LG_TR_VOL` is highly skewed (γ1 = 40.5592603)	Skewed
`TR_VOL` has 630544 (49.8%) zeros	Zeros
`SM_TR_VOL` has 715634 (56.5%) zeros	Zeros
`MD_TR_VOL` has 1026404 (81.0%) zeros	Zeros
`LG_TR_VOL` has 1232613 (97.3%) zeros	Zeros
`TRVL_SPD` has 630544 (49.8%) zeros	Zeros
`OCCUPY_RATE` has 624936 (49.3%) zeros	Zeros
`AVG_CAR_LEN` has 633053 (50.0%) zeros	Zeros
`AVG_CAR_TM` has 430682 (34.0%) zeros	Zeros

Reproduction

Analysis started	2024-03-26 00:37:06.655851
Analysis finished	2024-03-26 00:38:18.719193
Duration	1 minute and 12.06 seconds
Software version	ydata-profiling vv4.7.0
Download configuration	config.json

REG_YMDHMS
Date

Distinct	80942
Distinct (%)	6.4%
Missing	0
Missing (%)	0.0%
Memory size	9.7 MiB

Minimum	2020-01-19 00:00:00
Maximum	2020-01-19 23:59:58

Histogram

Histogram with fixed size bins (bins=50)

DETR_ID
Text

Distinct	443
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.7 MiB

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	11401056
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	DET002905
2nd row	DET004902
3rd row	DET006102
4th row	DET003501
5th row	DET003503

Value	Count	Frequency (%)
det010203	2880	0.2%
det000302	2880	0.2%
det002801	2880	0.2%
det005603	2880	0.2%
det002502	2880	0.2%
det002503	2880	0.2%
det012201	2880	0.2%
det002401	2880	0.2%
det002403	2880	0.2%
det012401	2880	0.2%
Other values (433)	1237984	97.7%

Most occurring characters

Value	Count	Frequency (%)
0	3813943	33.5%
D	1266784	11.1%
E	1266784	11.1%
T	1266784	11.1%
1	936704	8.2%
2	689036	6.0%
3	533594	4.7%
4	398401	3.5%
5	274831	2.4%
8	256009	2.2%
Other values (3)	698186	6.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	11401056	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	3813943	33.5%
D	1266784	11.1%
E	1266784	11.1%
T	1266784	11.1%
1	936704	8.2%
2	689036	6.0%
3	533594	4.7%
4	398401	3.5%
5	274831	2.4%
8	256009	2.2%
Other values (3)	698186	6.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	11401056	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	3813943	33.5%
D	1266784	11.1%
E	1266784	11.1%
T	1266784	11.1%
1	936704	8.2%
2	689036	6.0%
3	533594	4.7%
4	398401	3.5%
5	274831	2.4%
8	256009	2.2%
Other values (3)	698186	6.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	11401056	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	3813943	33.5%
D	1266784	11.1%
E	1266784	11.1%
T	1266784	11.1%
1	936704	8.2%
2	689036	6.0%
3	533594	4.7%
4	398401	3.5%
5	274831	2.4%
8	256009	2.2%
Other values (3)	698186	6.1%

VDS_ID
Text

Distinct	125
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.7 MiB

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	8867488
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	VDS0029
2nd row	VDS0049
3rd row	VDS0061
4th row	VDS0035
5th row	VDS0035

Value	Count	Frequency (%)
vds0023	17280	1.4%
vds0005	17274	1.4%
vds0059	14400	1.1%
vds0055	14400	1.1%
vds0028	14400	1.1%
vds0029	14395	1.1%
vds0022	14390	1.1%
vds0077	14385	1.1%
vds0087	14385	1.1%
vds0098	14380	1.1%
Other values (115)	1117095	88.2%

Most occurring characters

Value	Count	Frequency (%)
0	2547159	28.7%
V	1266784	14.3%
D	1266784	14.3%
S	1266784	14.3%
1	581519	6.6%
2	333851	3.8%
7	245163	2.8%
8	244489	2.8%
5	230245	2.6%
6	226570	2.6%
Other values (3)	658140	7.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8867488	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	2547159	28.7%
V	1266784	14.3%
D	1266784	14.3%
S	1266784	14.3%
1	581519	6.6%
2	333851	3.8%
7	245163	2.8%
8	244489	2.8%
5	230245	2.6%
6	226570	2.6%
Other values (3)	658140	7.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8867488	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	2547159	28.7%
V	1266784	14.3%
D	1266784	14.3%
S	1266784	14.3%
1	581519	6.6%
2	333851	3.8%
7	245163	2.8%
8	244489	2.8%
5	230245	2.6%
6	226570	2.6%
Other values (3)	658140	7.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8867488	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	2547159	28.7%
V	1266784	14.3%
D	1266784	14.3%
S	1266784	14.3%
1	581519	6.6%
2	333851	3.8%
7	245163	2.8%
8	244489	2.8%
5	230245	2.6%
6	226570	2.6%
Other values (3)	658140	7.4%

VDS_SECTN_ID
Text

Distinct	142
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.7 MiB

Length

Max length	12
Median length	12
Mean length	12
Min length	12

Characters and Unicode

Total characters	15201408
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	VL1850000032
2nd row	VL1840000053
3rd row	VL1880000067
4th row	VL1850000038
5th row	VL1850000038

Value	Count	Frequency (%)
vl1860000026	17280	1.4%
vl1860000007	17274	1.4%
vl1830000065	14400	1.1%
vl1850000031	14400	1.1%
vl1850000032	14395	1.1%
vl1860000025	14390	1.1%
vl1880000113	14380	1.1%
vl1880000115	14380	1.1%
vl1860000008	14380	1.1%
vl1880000095	14375	1.1%
Other values (132)	1117130	88.2%

Most occurring characters

Value	Count	Frequency (%)
0	6263477	41.2%
8	2180135	14.3%
1	1747022	11.5%
V	1266784	8.3%
L	1266784	8.3%
2	579212	3.8%
5	489245	3.2%
3	356204	2.3%
6	341154	2.2%
7	281990	1.9%
Other values (2)	429401	2.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	15201408	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	6263477	41.2%
8	2180135	14.3%
1	1747022	11.5%
V	1266784	8.3%
L	1266784	8.3%
2	579212	3.8%
5	489245	3.2%
3	356204	2.3%
6	341154	2.2%
7	281990	1.9%
Other values (2)	429401	2.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	15201408	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	6263477	41.2%
8	2180135	14.3%
1	1747022	11.5%
V	1266784	8.3%
L	1266784	8.3%
2	579212	3.8%
5	489245	3.2%
3	356204	2.3%
6	341154	2.2%
7	281990	1.9%
Other values (2)	429401	2.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	15201408	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	6263477	41.2%
8	2180135	14.3%
1	1747022	11.5%
V	1266784	8.3%
L	1266784	8.3%
2	579212	3.8%
5	489245	3.2%
3	356204	2.3%
6	341154	2.2%
7	281990	1.9%
Other values (2)	429401	2.8%

DAY_CLS
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.7 MiB

1	1266784

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1266784
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	1266784	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	1266784	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	1266784	100.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1266784	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	1266784	100.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1266784	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	1266784	100.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1266784	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	1266784	100.0%

DETR_FAIL_YN
Categorical

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.7 MiB

0	1266775
3	9

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1266784
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	1266775	> 99.9%
3	9	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	1266775	> 99.9%
3	9	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	1266775	> 99.9%
3	9	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1266784	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	1266775	> 99.9%
3	9	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1266784	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	1266775	> 99.9%
3	9	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1266784	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	1266775	> 99.9%
3	9	< 0.1%

TR_VOL
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	38
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.5924838

Minimum	0
Maximum	110
Zeros	630544
Zeros (%)	49.8%
Negative	0
Negative (%)	0.0%
Memory size	9.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	7
Maximum	110
Range	110
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.5177467
Coefficient of variation (CV)	1.5810187
Kurtosis	12.225642
Mean	1.5924838
Median Absolute Deviation (MAD)	1
Skewness	2.4277347
Sum	2017333
Variance	6.3390485
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
0	630544	49.8%
1	229281	18.1%
2	127657	10.1%
3	79794	6.3%
4	54988	4.3%
5	38967	3.1%
6	28558	2.3%
7	21321	1.7%
8	15965	1.3%
9	12209	1.0%
Other values (28)	27500	2.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	630544	49.8%
1	229281	18.1%
2	127657	10.1%
3	79794	6.3%
4	54988	4.3%
5	38967	3.1%
6	28558	2.3%
7	21321	1.7%
8	15965	1.3%
9	12209	1.0%

Value	Count	Frequency (%)
110	1	< 0.1%
101	1	< 0.1%
85	1	< 0.1%
70	1	< 0.1%
61	1	< 0.1%
50	1	< 0.1%
47	1	< 0.1%
43	1	< 0.1%
40	1	< 0.1%
31	1	< 0.1%

SM_TR_VOL
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	25
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.1863277

Minimum	0
Maximum	33
Zeros	715634
Zeros (%)	56.5%
Negative	0
Negative (%)	0.0%
Memory size	9.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	2
95-th percentile	6
Maximum	33
Range	33
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.0358248
Coefficient of variation (CV)	1.7160728
Kurtosis	7.8467613
Mean	1.1863277
Median Absolute Deviation (MAD)	0
Skewness	2.5428303
Sum	1502821
Variance	4.1445826
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
0	715634	56.5%
1	226774	17.9%
2	115834	9.1%
3	68828	5.4%
4	44840	3.5%
5	30417	2.4%
6	20929	1.7%
7	14325	1.1%
8	10261	0.8%
9	7006	0.6%
Other values (15)	11936	0.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	715634	56.5%
1	226774	17.9%
2	115834	9.1%
3	68828	5.4%
4	44840	3.5%
5	30417	2.4%
6	20929	1.7%
7	14325	1.1%
8	10261	0.8%
9	7006	0.6%

Value	Count	Frequency (%)
33	1	< 0.1%
24	1	< 0.1%
22	1	< 0.1%
21	2	< 0.1%
20	2	< 0.1%
19	9	< 0.1%
18	23	< 0.1%
17	58	< 0.1%
16	126	< 0.1%
15	327	< 0.1%

MD_TR_VOL
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.35590282

Minimum	0
Maximum	18
Zeros	1026404
Zeros (%)	81.0%
Negative	0
Negative (%)	0.0%
Memory size	9.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	18
Range	18
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.99810581
Coefficient of variation (CV)	2.8044336
Kurtosis	30.314348
Mean	0.35590282
Median Absolute Deviation (MAD)	0
Skewness	4.6693272
Sum	450852
Variance	0.99621522
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
0	1026404	81.0%
1	144250	11.4%
2	48013	3.8%
3	21349	1.7%
4	10978	0.9%
5	6228	0.5%
6	3652	0.3%
7	2330	0.2%
8	1454	0.1%
9	893	0.1%
Other values (8)	1233	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1026404	81.0%
1	144250	11.4%
2	48013	3.8%
3	21349	1.7%
4	10978	0.9%
5	6228	0.5%
6	3652	0.3%
7	2330	0.2%
8	1454	0.1%
9	893	0.1%

Value	Count	Frequency (%)
18	1	< 0.1%
16	9	< 0.1%
15	10	< 0.1%
14	41	< 0.1%
13	98	< 0.1%
12	172	< 0.1%
11	342	< 0.1%
10	560	< 0.1%
9	893	0.1%
8	1454	0.1%

LG_TR_VOL
Real number (ℝ)

SKEWED ZEROS

Distinct	33
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.050251661

Minimum	0
Maximum	110
Zeros	1232613
Zeros (%)	97.3%
Negative	0
Negative (%)	0.0%
Memory size	9.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	110
Range	110
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.47894159
Coefficient of variation (CV)	9.5308609
Kurtosis	5587.239
Mean	0.050251661
Median Absolute Deviation (MAD)	0
Skewness	40.55926
Sum	63658
Variance	0.22938505
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=33)

Value	Count	Frequency (%)
0	1232613	97.3%
1	24515	1.9%
2	3961	0.3%
3	1879	0.1%
4	1060	0.1%
5	684	0.1%
6	527	< 0.1%
7	372	< 0.1%
8	316	< 0.1%
9	276	< 0.1%
Other values (23)	581	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1232613	97.3%
1	24515	1.9%
2	3961	0.3%
3	1879	0.1%
4	1060	0.1%
5	684	0.1%
6	527	< 0.1%
7	372	< 0.1%
8	316	< 0.1%
9	276	< 0.1%

Value	Count	Frequency (%)
110	1	< 0.1%
101	1	< 0.1%
85	1	< 0.1%
70	1	< 0.1%
61	1	< 0.1%
50	1	< 0.1%
47	1	< 0.1%
43	1	< 0.1%
31	1	< 0.1%
29	1	< 0.1%

TRVL_SPD
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	206
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	28.082826

Minimum	0
Maximum	227
Zeros	630544
Zeros (%)	49.8%
Negative	0
Negative (%)	0.0%
Memory size	9.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	10
Q3	55
95-th percentile	76
Maximum	227
Range	227
Interquartile range (IQR)	55

Descriptive statistics

Standard deviation	30.612413
Coefficient of variation (CV)	1.0900759
Kurtosis	-0.45329385
Mean	28.082826
Median Absolute Deviation (MAD)	10
Skewness	0.56979673
Sum	35574875
Variance	937.11981
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	630544	49.8%
54	18994	1.5%
55	18829	1.5%
56	18557	1.5%
52	18553	1.5%
53	18536	1.5%
57	18301	1.4%
51	18099	1.4%
50	17745	1.4%
58	17735	1.4%
Other values (196)	470891	37.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	630544	49.8%
1	46	< 0.1%
2	47	< 0.1%
3	135	< 0.1%
4	169	< 0.1%
5	964	0.1%
6	309	< 0.1%
7	308	< 0.1%
8	330	< 0.1%
9	385	< 0.1%

Value	Count	Frequency (%)
227	1	< 0.1%
225	1	< 0.1%
220	1	< 0.1%
216	1	< 0.1%
201	13	< 0.1%
200	714	0.1%
199	2	< 0.1%
198	3	< 0.1%
197	3	< 0.1%
196	5	< 0.1%

OCCUPY_RATE
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	5207
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.0802075

Minimum	0
Maximum	100
Zeros	624936
Zeros (%)	49.3%
Negative	0
Negative (%)	0.0%
Memory size	9.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.44
Q3	3.33
95-th percentile	12.23
Maximum	100
Range	100
Interquartile range (IQR)	3.33

Descriptive statistics

Standard deviation	8.3465006
Coefficient of variation (CV)	2.7097202
Kurtosis	88.726438
Mean	3.0802075
Median Absolute Deviation (MAD)	0.44
Skewness	8.3843934
Sum	3901957.6
Variance	69.664073
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	624936	49.3%
1.33	16774	1.3%
1.22	16464	1.3%
1.44	15997	1.3%
1.11	14601	1.2%
1.55	12309	1.0%
1	11996	0.9%
1.89	11439	0.9%
1.78	11328	0.9%
2	10762	0.8%
Other values (5197)	520178	41.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	624936	49.3%
0.1	92	< 0.1%
0.11	70	< 0.1%
0.12	55	< 0.1%
0.13	35	< 0.1%
0.14	26	< 0.1%
0.15	212	< 0.1%
0.16	44	< 0.1%
0.17	64	< 0.1%
0.18	57	< 0.1%

Value	Count	Frequency (%)
100	5977	0.5%
99.42	1	< 0.1%
99.29	1	< 0.1%
99.27	1	< 0.1%
99.23	1	< 0.1%
98.42	1	< 0.1%
98.22	1	< 0.1%
98.1	1	< 0.1%
97.8	1	< 0.1%
97.76	1	< 0.1%

AVG_CAR_LEN
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	256
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	33.127243

Minimum	0
Maximum	255
Zeros	633053
Zeros (%)	50.0%
Negative	0
Negative (%)	0.0%
Memory size	9.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	49
95-th percentile	107
Maximum	255
Range	255
Interquartile range (IQR)	49

Descriptive statistics

Standard deviation	44.716374
Coefficient of variation (CV)	1.3498369
Kurtosis	4.5550465
Mean	33.127243
Median Absolute Deviation (MAD)	1
Skewness	1.8869528
Sum	41965061
Variance	1999.5541
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	633053	50.0%
91	104533	8.3%
49	45345	3.6%
50	39516	3.1%
46	26974	2.1%
45	21051	1.7%
47	20430	1.6%
44	18536	1.5%
48	17769	1.4%
43	16850	1.3%
Other values (246)	322727	25.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	633053	50.0%
1	465	< 0.1%
2	257	< 0.1%
3	517	< 0.1%
4	347	< 0.1%
5	509	< 0.1%
6	309	< 0.1%
7	587	< 0.1%
8	299	< 0.1%
9	471	< 0.1%

Value	Count	Frequency (%)
255	361	< 0.1%
254	150	< 0.1%
253	291	< 0.1%
252	233	< 0.1%
251	434	< 0.1%
250	174	< 0.1%
249	329	< 0.1%
248	176	< 0.1%
247	389	< 0.1%
246	150	< 0.1%

AVG_CAR_TM
Real number (ℝ)

ZEROS

Distinct	241
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16.789598

Minimum	0
Maximum	254
Zeros	430682
Zeros (%)	34.0%
Negative	0
Negative (%)	0.0%
Memory size	9.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	10
Q3	30
95-th percentile	60
Maximum	254
Range	254
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	18.138137
Coefficient of variation (CV)	1.0803199
Kurtosis	2.2547614
Mean	16.789598
Median Absolute Deviation (MAD)	10
Skewness	1.1305037
Sum	21268794
Variance	328.992
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	430682	34.0%
30	396499	31.3%
60	88871	7.0%
15	68561	5.4%
10	46358	3.7%
7	35598	2.8%
3	31930	2.5%
6	28523	2.3%
5	23726	1.9%
4	21137	1.7%
Other values (231)	94899	7.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	430682	34.0%
1	1182	0.1%
2	18373	1.5%
3	31930	2.5%
4	21137	1.7%
5	23726	1.9%
6	28523	2.3%
7	35598	2.8%
8	6817	0.5%
9	5285	0.4%

Value	Count	Frequency (%)
254	1	< 0.1%
248	1	< 0.1%
247	1	< 0.1%
245	4	< 0.1%
244	2	< 0.1%
243	1	< 0.1%
242	2	< 0.1%
241	2	< 0.1%
240	1	< 0.1%
239	2	< 0.1%

ETL_TYPE
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.7 MiB

602	1266784

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	3800352
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	602
2nd row	602
3rd row	602
4th row	602
5th row	602

Common Values

Value	Count	Frequency (%)
602	1266784	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
602	1266784	100.0%

Most occurring characters

Value	Count	Frequency (%)
6	1266784	33.3%
0	1266784	33.3%
2	1266784	33.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3800352	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
6	1266784	33.3%
0	1266784	33.3%
2	1266784	33.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3800352	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
6	1266784	33.3%
0	1266784	33.3%
2	1266784	33.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3800352	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
6	1266784	33.3%
0	1266784	33.3%
2	1266784	33.3%

ETL_DATE
Categorical

Distinct	49
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.7 MiB

2020-01-20 03:33:51	54048
2020-01-20 03:34:32	50422
2020-01-20 03:34:17	50276
2020-01-20 03:34:39	48578
2020-01-20 03:34:11	48543
Other values (44)	1014917

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	24068896
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2020-01-20 03:33:51
2nd row	2020-01-20 03:33:51
3rd row	2020-01-20 03:33:51
4th row	2020-01-20 03:33:51
5th row	2020-01-20 03:33:51

Common Values

Value	Count	Frequency (%)
2020-01-20 03:33:51	54048	4.3%
2020-01-20 03:34:32	50422	4.0%
2020-01-20 03:34:17	50276	4.0%
2020-01-20 03:34:39	48578	3.8%
2020-01-20 03:34:11	48543	3.8%
2020-01-20 03:34:42	48127	3.8%
2020-01-20 03:34:21	47058	3.7%
2020-01-20 03:34:00	45780	3.6%
2020-01-20 03:34:29	45218	3.6%
2020-01-20 03:34:26	43989	3.5%
Other values (39)	784745	61.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2020-01-20	1266784	50.0%
03:33:51	54048	2.1%
03:34:32	50422	2.0%
03:34:17	50276	2.0%
03:34:39	48578	1.9%
03:34:11	48543	1.9%
03:34:42	48127	1.9%
03:34:21	47058	1.9%
03:34:00	45780	1.8%
03:34:29	45218	1.8%
Other values (40)	828734	32.7%

Most occurring characters

Value	Count	Frequency (%)
0	6654312	27.6%
2	4172258	17.3%
3	2959618	12.3%
-	2533568	10.5%
:	2533568	10.5%
1	1678817	7.0%
4	1441933	6.0%
	1266784	5.3%
5	359755	1.5%
9	168683	0.7%
Other values (3)	299600	1.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	24068896	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	6654312	27.6%
2	4172258	17.3%
3	2959618	12.3%
-	2533568	10.5%
:	2533568	10.5%
1	1678817	7.0%
4	1441933	6.0%
	1266784	5.3%
5	359755	1.5%
9	168683	0.7%
Other values (3)	299600	1.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	24068896	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	6654312	27.6%
2	4172258	17.3%
3	2959618	12.3%
-	2533568	10.5%
:	2533568	10.5%
1	1678817	7.0%
4	1441933	6.0%
	1266784	5.3%
5	359755	1.5%
9	168683	0.7%
Other values (3)	299600	1.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	24068896	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	6654312	27.6%
2	4172258	17.3%
3	2959618	12.3%
-	2533568	10.5%
:	2533568	10.5%
1	1678817	7.0%
4	1441933	6.0%
	1266784	5.3%
5	359755	1.5%
9	168683	0.7%
Other values (3)	299600	1.2%

Auto

Heatmap
Table

	AVG_CAR_LEN	AVG_CAR_TM	DETR_FAIL_YN	ETL_DATE	LG_TR_VOL	MD_TR_VOL	OCCUPY_RATE	SM_TR_VOL	TRVL_SPD	TR_VOL
AVG_CAR_LEN	1.000	-0.105	0.013	0.121	0.191	0.413	0.837	0.743	0.857	0.851
AVG_CAR_TM	-0.105	1.000	0.000	0.062	-0.029	-0.023	-0.085	-0.116	-0.063	-0.098
DETR_FAIL_YN	0.013	0.000	1.000	0.010	0.016	-0.001	0.005	-0.001	0.001	0.005
ETL_DATE	0.121	0.062	0.010	1.000	0.037	0.102	0.227	0.221	0.160	0.228
LG_TR_VOL	0.191	-0.029	0.016	0.037	1.000	0.039	0.199	0.024	0.136	0.182
MD_TR_VOL	0.413	-0.023	-0.001	0.102	0.039	1.000	0.569	0.307	0.449	0.564
OCCUPY_RATE	0.837	-0.085	0.005	0.227	0.199	0.569	1.000	0.855	0.791	0.961
SM_TR_VOL	0.743	-0.116	-0.001	0.221	0.024	0.307	0.855	1.000	0.760	0.908
TRVL_SPD	0.857	-0.063	0.001	0.160	0.136	0.449	0.791	0.760	1.000	0.853
TR_VOL	0.851	-0.098	0.005	0.228	0.182	0.564	0.961	0.908	0.853	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	REG_YMDHMS	DETR_ID	VDS_ID	VDS_SECTN_ID	DAY_CLS	TR_VOL	SM_TR_VOL	MD_TR_VOL	TRVL_SPD	OCCUPY_RATE	AVG_CAR_LEN	AVG_CAR_TM	ETL_TYPE	ETL_DATE
0	2020-01-19 00:40:44	DET002905	VDS0029	VL1850000032	1	0	0	0	0.0	0.00	0.0	30.0	602	2020-01-20 03:33:51
1	2020-01-19 00:40:44	DET004902	VDS0049	VL1840000053	1	0	0	0	0.0	0.00	0.0	30.0	602	2020-01-20 03:33:51
2	2020-01-19 00:40:44	DET006102	VDS0061	VL1880000067	1	0	0	0	0.0	0.00	0.0	0.0	602	2020-01-20 03:33:51
3	2020-01-19 00:40:45	DET003501	VDS0035	VL1850000038	1	0	0	0	0.0	0.00	0.0	30.0	602	2020-01-20 03:33:51
4	2020-01-19 00:40:45	DET003503	VDS0035	VL1850000038	1	2	0	2	84.0	2.78	58.0	15.0	602	2020-01-20 03:33:51
5	2020-01-19 00:40:45	DET004001	VDS0040	VL1830000043	1	0	0	0	0.0	0.00	0.0	30.0	602	2020-01-20 03:33:51
6	2020-01-19 00:40:45	DET004003	VDS0040	VL1830000044	1	0	0	0	0.0	0.00	0.0	30.0	602	2020-01-20 03:33:51
7	2020-01-19 00:40:45	DET005502	VDS0055	VL1850000059	1	0	0	0	0.0	0.00	0.0	30.0	602	2020-01-20 03:33:51
8	2020-01-19 00:40:45	DET005504	VDS0055	VL1850000060	1	0	0	0	0.0	0.00	0.0	30.0	602	2020-01-20 03:33:51
9	2020-01-19 00:40:46	DET002201	VDS0022	VL1860000025	1	1	1	0	56.0	1.33	39.0	30.0	602	2020-01-20 03:33:51

	REG_YMDHMS	DETR_ID	VDS_ID	VDS_SECTN_ID	DAY_CLS	TR_VOL	SM_TR_VOL	MD_TR_VOL	LG_TR_VOL	TRVL_SPD	OCCUPY_RATE	AVG_CAR_LEN	AVG_CAR_TM	ETL_TYPE	ETL_DATE
1266774	2020-01-19 09:43:46	DET002204	VDS0022	VL1860000025	1	2	1	1	0	59.0	2.67	48.0	15.0	602	2020-01-20 03:34:21
1266775	2020-01-19 09:43:46	DET002601	VDS0026	VL1850000029	1	1	1	0	0	38.0	1.55	40.0	30.0	602	2020-01-20 03:34:21
1266776	2020-01-19 09:43:46	DET002603	VDS0026	VL1850000029	1	0	0	0	0	0.0	0.00	0.0	30.0	602	2020-01-20 03:34:21
1266777	2020-01-19 09:43:46	DET004902	VDS0049	VL1840000053	1	0	0	0	0	0.0	0.00	0.0	30.0	602	2020-01-20 03:34:21
1266778	2020-01-19 09:43:46	DET006102	VDS0061	VL1880000067	1	4	4	0	0	58.0	4.67	91.0	10.0	602	2020-01-20 03:34:21
1266779	2020-01-19 09:43:46	DET008601	VDS0086	VL1880000097	1	4	4	0	0	57.0	4.78	192.0	13.0	602	2020-01-20 03:34:21
1266780	2020-01-19 09:43:46	DET008603	VDS0086	VL1880000098	1	0	0	0	0	0.0	0.00	0.0	0.0	602	2020-01-20 03:34:21
1266781	2020-01-19 09:43:46	DET009601	VDS0096	VL1880000111	1	1	1	0	0	84.0	1.11	91.0	0.0	602	2020-01-20 03:34:21
1266782	2020-01-19 09:43:46	DET009603	VDS0096	VL1880000111	1	1	0	1	0	44.0	3.44	56.0	0.0	602	2020-01-20 03:34:21
1266783	2020-01-19 09:43:47	DET004502	VDS0045	VL1850000049	1	3	2	0	1	44.0	4.90	22.0	10.0	602	2020-01-20 03:34:21

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)